Changes are coming to https://stigviewer.com.
Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey
The vRA PostgreSQL database must set the log_statement to all.
Overview
| Finding ID | Version | Rule ID | IA Controls | Severity |
|---|---|---|---|---|
| V-89421 | VRAU-PG-000405 | SV-100071r1_rule | Medium |
| Description |
|---|
| The removal of security objects from the database/DBMS would seriously degrade a system's information assurance posture. If such an event occurs, it must be logged. |
| STIG | Date |
|---|---|
| VMW vRealize Automation 7.x PostgreSQL Security Technical Implementation Guide | 2018-10-12 |
Details
| Check Text ( C-89113r1_chk ) |
|---|
| At the command prompt, execute the following command: # grep '^\s*log_statement\b' /storage/db/pgdata/postgresql.conf If "log_statement" is not all, this is a finding. |
| Fix Text (F-96163r1_fix) |
|---|
| At the command prompt, execute the following commands: # /opt/vmware/vpostgres/current/bin/psql -U postgres -c "ALTER SYSTEM SET log_statement TO 'all';" # /opt/vmware/vpostgres/current/bin/psql -U postgres -c "SELECT pg_reload_conf();" |